Java Programs written by Vito A. Volpe, Jr., M.S.I.S.

The purpose of this program is to read a '.prn' file with Copier, Trustee or Investment charges generated from an Excel template.  You can also read Journal Vouchers, JPM Chase and Budget charges/changes.  This program reads the '.prn' file and puts this information in FUPLOAD format to be fed into Banner Finance.

The purpose of this program is to read a '.prn' file with Gourmet Dining charges generated from an Excel template. This program reads the '.prn' file and puts this information in FUPLOAD format to be fed into Banner Finance.

Read a file with a list of employees that don't have an active assignment and compare

that to the FOBPROF table. If there is a match and the ID has Self-Service access

put them on the output list to have their Self-Service access removed.

Read a file specified by the user of Raisers Edge System in Alumni Development and create a file in FUPLOAD format that will be fed into Banner.

Read a JPM Chase mapper file and compare that to another file of transaction IDs that don't match the central billing file. Write out the mapper file except for the records in the transaction ID file that don't match. While doing this do a transaction count and total count.

Read a BOA mapper file and compare that to another file of transaction IDs that don't match the central billing file. Write out the mapper file except for the records in the transaction ID file that don't match. While doing this do a transaction count and total count.

Read a file specified by the user Budget Office and create a file in GURFEED format that will be fed into Banner. This is salary savings that gets put back in the budget.

Read a file with a list of Index codes and return the Program code to an output file. I wrote this program in anticipation of ODBC not working in Amazon Workspace. This can be used with the university budget upload.